Access 2016 - Table Relationships and Importing Data

      This course is part of the MOS exam 77-730 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) certification exam.

In this course you will learn about Table Relationships and Importing Data.
     
      Table Relationships      
      Upon successful completion you will be able to:

1. Use the Relationships Window;
2. Create Relationships;
3. Select Tables;
4. Understand Referential Integrity;
5. Edit Relationships;
6. Remove Relationships;
7. Hide/Show Tables;
8. Use Many-to-Many Relationships;
9. Create Link Tables.
     
      Importing Data      
      Upon successful completion you will be able to:

1. Import Data into Access;
2. Use Import Options;
3. Import from Access Database;
4. Import from Excel Spreadsheet;
5. Append Imported Data;
6. Create Linked Tables;
7. Update Linked Tables.
     
This course can be purchased either individaully or as part of a package.
Single Training Course - Access 2016 - Table Relationships and Importing Data :
Program Training Courses - Microsoft Access 2016 :
Office Suite Training Courses - Microsoft Office 2016 :
© 2017 Online Training Masters